select distinct(dvct.[DON_VI_ID]), dv.[DON_VI], nd.[TAI_KHOAN]
from [NV].[DONVI_CHITIEU] as dvct
left join [DM].[DONVI] as dv on dv.[DON_VI_ID] = dvct.[DON_VI_ID]
left join [NV].[NGUOIDUNG_DONVI] as nddv on nddv.[DON_VI_ID] = dvct.[DON_VI_ID]
left join [DM].[NGUOIDUNG] as nd on nd.[NGUOI_DUNG_ID] = nddv.[NGUOI_DUNG_ID] and nd.[IS_ADMIN] = 0
where [NAM_KE_HOACH_ID] = 2016
and [FLAG] = 1;
